<%
   com.pub.database.QueryBean qbnDAO=null;
   String lstrDBAlias=request.getParameter("DB_ALIAS");
   String lstrDBDebug=request.getParameter("DEBUG");
   String lstrSrcCharset=request.getParameter("SOURCE_CHARSET");
   String lstrTgrCharset=request.getParameter("TARGET_CHARSET");

   String lstrEmpName=null;

   try{

     qbnDAO=new com.pub.database.QueryBean(lstrDBAlias,Boolean.valueOf(lstrDBDebug).booleanValue(),lstrSrcCharset,lstrTgrCharset);

     lstrEmpName=qbnDAO.readSingleValueData("select employee_name_c from pnl_employee where employee_no='" + request.getParameter("empno") + "' and employee_st='A'");
   }
   catch(Exception e){
     e.printStackTrace();
   }
   finally{
     try{qbnDAO.close();}catch(Exception e){e.printStackTrace();}
     qbnDAO=null;
   }
%>
<%out.println("<?xml version='1.0' encoding='UTF-8'?>"); %>
<dataset>
    <row>
        <Name><%=lstrEmpName%></Name>
    </row>
</dataset>
